Dataset info
| Number of variables | 37 |
|---|---|
| Number of observations | 83001 |
| Missing cells | 204622 (6.7%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 23.4 MiB |
| Average record size in memory | 296.0 B |
Variables types
| Numeric | 27 |
|---|---|
| Categorical | 7 |
| Boolean | 0 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 3 |
| Unsupported | 0 |
Warnings
amenities has a high cardinality: 72957 distinct values | Warning |
bedrooms has 5083 (6.1%) zeros | Zeros |
beds has 2123 (2.6%) zeros | Zeros |
calculated_host_listings_count_entire_homes is highly correlated with calculated_host_listings_count (ρ = 0.9985904365) | Rejected |
calculated_host_listings_count_private_rooms has 40010 (48.2%) zeros | Zeros |
calculated_host_listings_count_shared_rooms has 81831 (98.6%) zeros | Zeros |
cleaning_fee has 27272 (32.9%) zeros | Zeros |
extra_people has 50746 (61.1%) zeros | Zeros |
host_listings_count is highly correlated with calculated_host_listings_count_entire_homes (ρ = 0.9820095924) | Rejected |
host_response_rate has 1097 (1.3%) zeros | Zeros |
host_response_rate has 24307 (29.3%) missing values | Missing |
host_total_listings_count is highly correlated with host_listings_count (ρ = 1) | Rejected |
number_of_reviews has 20792 (25.1%) zeros | Zeros |
number_of_reviews_ltm has 33561 (40.4%) zeros | Zeros |
price is highly skewed (γ1 = 25.10330353) | Skewed |
review_scores_accuracy has 22485 (27.1%) missing values | Missing |
review_scores_checkin has 22537 (27.2%) missing values | Missing |
review_scores_cleanliness has 22474 (27.1%) missing values | Missing |
review_scores_communication has 22482 (27.1%) missing values | Missing |
review_scores_location has 22536 (27.2%) missing values | Missing |
review_scores_rating has 22434 (27.0%) missing values | Missing |
review_scores_value has 22535 (27.2%) missing values | Missing |
reviews_per_month has 20791 (25.0%) missing values | Missing |
security_deposit has 47852 (57.7%) zeros | Zeros |
zipcode has a high cardinality: 33819 distinct values | Warning |
zipcode has 1947 (2.3%) missing values | Missing |
accommodates
Numeric
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.18722666 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 2 |
| Q3 | 4 |
| 95-th percentile | 7 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 2.012540496 |
|---|---|
| Coef of variation | 0.6314394021 |
| Kurtosis | 4.401819508 |
| Mean | 3.18722666 |
| MAD | 1.577924631 |
| Skewness | 1.688858785 |
| Sum | 264543 |
| Variance | 4.050319249 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 2 | 34941 | 42.1% | |
| 4 | 16509 | 19.9% | |
| 1 | 10488 | 12.6% | |
| 6 | 6669 | 8.0% | |
| 3 | 5656 | 6.8% | |
| 5 | 3877 | 4.7% | |
| 8 | 2016 | 2.4% | |
| 7 | 1360 | 1.6% | |
| 10 | 530 | 0.6% | |
| 9 | 407 | 0.5% | |
| Other values (7) | 548 | 0.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 10488 | 12.6% | |
| 2 | 34941 | 42.1% | |
| 3 | 5656 | 6.8% | |
| 4 | 16509 | 19.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 16 | 102 | 0.1% | |
| 15 | 23 | < 0.1% | |
| 14 | 88 | 0.1% | |
| 13 | 49 | 0.1% | |
| 12 | 178 | 0.2% |
amenities
Categorical
| Distinct count | 72957 |
|---|---|
| Unique (%) | 87.9% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| {} | 378 |
|---|---|
| {TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed",Heating,"Suitable for events",Washer,Dryer,"Smoke detector","First aid kit",Essentials,"Hair dryer"} | 100 |
| {Wifi,Kitchen,Elevator,Heating,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Hot water","Bed linens","Extra pillows and blankets",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed","Well-lit path to entrance"} | 93 |
| Other values (72954) |
| Value | Count | Frequency (%) | |
| {} | 378 | 0.5% | |
| {TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed",Heating,"Suitable for events",Washer,Dryer,"Smoke detector","First aid kit",Essentials,"Hair dryer"} | 100 | 0.1% | |
| {Wifi,Kitchen,Elevator,Heating,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Hot water","Bed linens","Extra pillows and blankets",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed","Well-lit path to entrance"} | 93 | 0.1% | |
| {Wifi,Kitchen,Heating,Washer,Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hot water","Bed linens"} | 66 | 0.1% | |
| {TV,Wifi,Kitchen,Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,Iron} | 63 | 0.1% | |
| {TV,Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 47 | 0.1% | |
| {TV,Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 42 | 0.1% | |
| {TV,Wifi,Kitchen,Heating,Washer,"Smoke detector",Essentials,Shampoo,Hangers,Iron,"Hot water","Bed linens",Microwave,Refrigerator,Dishwasher,"Dishes and silverware",Oven,Stove} | 33 | < 0.1% | |
| {TV,Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance"} | 33 | < 0.1% | |
| {"translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"} | 33 | < 0.1% | |
| Other values (72947) | 82113 | 98.9% |
| Max length | 1572 |
|---|---|
| Mean length | 277.0123011 |
| Min length | 2 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
bathrooms
Numeric
| Distinct count | 25 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.294755485 |
|---|---|
| Minimum | 0 |
| Maximum | 24 |
| Zeros (%) | 0.5% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1.5 |
| 95-th percentile | 2.5 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range | 0.5 |
Descriptive statistics
| Standard deviation | 0.6188631928 |
|---|---|
| Coef of variation | 0.4779768844 |
| Kurtosis | 54.83128571 |
| Mean | 1.294755485 |
| MAD | 0.4371899041 |
| Skewness | 4.201405197 |
| Sum | 107466 |
| Variance | 0.3829916514 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 1 | 58808 | 70.9% | |
| 2 | 11922 | 14.4% | |
| 1.5 | 6768 | 8.2% | |
| 2.5 | 2319 | 2.8% | |
| 3 | 1359 | 1.6% | |
| 3.5 | 536 | 0.6% | |
| 0 | 443 | 0.5% | |
| 0.5 | 297 | 0.4% | |
| 4 | 264 | 0.3% | |
| 4.5 | 97 | 0.1% | |
| Other values (15) | 188 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 443 | 0.5% | |
| 0.5 | 297 | 0.4% | |
| 1 | 58808 | 70.9% | |
| 1.5 | 6768 | 8.2% | |
| 2 | 11922 | 14.4% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 24 | 1 | < 0.1% | |
| 17 | 2 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 10.5 | 1 | < 0.1% | |
| 10 | 24 | < 0.1% |
bed_type
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Real Bed | |
|---|---|
| Pull-out Sofa | 413 |
| Futon | 183 |
| Other values (2) | 117 |
| Value | Count | Frequency (%) | |
| Real Bed | 82288 | 99.1% | |
| Pull-out Sofa | 413 | 0.5% | |
| Futon | 183 | 0.2% | |
| Couch | 70 | 0.1% | |
| Airbed | 47 | 0.1% |
| Max length | 13 |
|---|---|
| Mean length | 8.014602234 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
bedrooms
Numeric
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.413380562 |
|---|---|
| Minimum | 0 |
| Maximum | 24 |
| Zeros (%) | 6.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 24 |
| Range | 24 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.9259544054 |
|---|---|
| Coef of variation | 0.6551345267 |
| Kurtosis | 15.41542839 |
| Mean | 1.413380562 |
| MAD | 0.6906776395 |
| Skewness | 2.212373846 |
| Sum | 117312 |
| Variance | 0.8573915608 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 1 | 51960 | 62.6% | |
| 2 | 17050 | 20.5% | |
| 3 | 5733 | 6.9% | |
| 0 | 5083 | 6.1% | |
| 4 | 2242 | 2.7% | |
| 5 | 690 | 0.8% | |
| 6 | 173 | 0.2% | |
| 7 | 41 | < 0.1% | |
| 8 | 12 | < 0.1% | |
| 10 | 7 | < 0.1% | |
| Other values (7) | 10 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 5083 | 6.1% | |
| 1 | 51960 | 62.6% | |
| 2 | 17050 | 20.5% | |
| 3 | 5733 | 6.9% | |
| 4 | 2242 | 2.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 24 | 1 | < 0.1% | |
| 22 | 1 | < 0.1% | |
| 21 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% |
beds
Numeric
| Distinct count | 25 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.745870532 |
|---|---|
| Minimum | 0 |
| Maximum | 55 |
| Zeros (%) | 2.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 55 |
| Range | 55 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.28404785 |
|---|---|
| Coef of variation | 0.7354771311 |
| Kurtosis | 52.21031206 |
| Mean | 1.745870532 |
| MAD | 0.9084654458 |
| Skewness | 3.602751761 |
| Sum | 144909 |
| Variance | 1.648778881 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 1 | 45578 | 54.9% | |
| 2 | 19996 | 24.1% | |
| 3 | 8347 | 10.1% | |
| 4 | 3867 | 4.7% | |
| 0 | 2123 | 2.6% | |
| 5 | 1558 | 1.9% | |
| 6 | 816 | 1.0% | |
| 7 | 311 | 0.4% | |
| 8 | 184 | 0.2% | |
| 9 | 73 | 0.1% | |
| Other values (15) | 148 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 2123 | 2.6% | |
| 1 | 45578 | 54.9% | |
| 2 | 19996 | 24.1% | |
| 3 | 8347 | 10.1% | |
| 4 | 3867 | 4.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 55 | 1 | < 0.1% | |
| 28 | 1 | < 0.1% | |
| 24 | 1 | < 0.1% | |
| 22 | 1 | < 0.1% | |
| 20 | 4 | < 0.1% |
calculated_host_listings_count
Numeric
| Distinct count | 83 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 25.48952422 |
|---|---|
| Minimum | 1 |
| Maximum | 1161 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 4 |
| 95-th percentile | 62 |
| Maximum | 1161 |
| Range | 1160 |
| Interquartile range | 3 |
Descriptive statistics
| Standard deviation | 136.6106959 |
|---|---|
| Coef of variation | 5.359483947 |
| Kurtosis | 62.49948003 |
| Mean | 25.48952422 |
| MAD | 40.07294315 |
| Skewness | 7.903121324 |
| Sum | 2115656 |
| Variance | 18662.48223 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 1 | 43014 | 51.8% | |
| 2 | 11793 | 14.2% | |
| 3 | 4729 | 5.7% | |
| 4 | 2863 | 3.4% | |
| 5 | 1795 | 2.2% | |
| 6 | 1341 | 1.6% | |
| 1161 | 1138 | 1.4% | |
| 7 | 1049 | 1.3% | |
| 8 | 892 | 1.1% | |
| 10 | 669 | 0.8% | |
| Other values (73) | 13718 | 16.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 43014 | 51.8% | |
| 2 | 11793 | 14.2% | |
| 3 | 4729 | 5.7% | |
| 4 | 2863 | 3.4% | |
| 5 | 1795 | 2.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1161 | 1138 | 1.4% | |
| 263 | 263 | 0.3% | |
| 213 | 209 | 0.3% | |
| 177 | 177 | 0.2% | |
| 164 | 164 | 0.2% |
calculated_host_listings_count_entire_homes
Highly correlated
This variable is highly correlated with calculated_host_listings_count and should be ignored for analysis
| Correlation | 0.9985904365 |
|---|
calculated_host_listings_count_private_rooms
Numeric
| Distinct count | 41 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.97228949 |
|---|---|
| Minimum | 0 |
| Maximum | 95 |
| Zeros (%) | 48.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 6 |
| Maximum | 95 |
| Range | 95 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 7.192389105 |
|---|---|
| Coef of variation | 3.646720798 |
| Kurtosis | 101.6009114 |
| Mean | 1.97228949 |
| MAD | 2.496535116 |
| Skewness | 9.14303938 |
| Sum | 163702 |
| Variance | 51.73046103 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 0 | 40010 | 48.2% | |
| 1 | 25400 | 30.6% | |
| 2 | 6715 | 8.1% | |
| 3 | 3646 | 4.4% | |
| 4 | 1633 | 2.0% | |
| 5 | 761 | 0.9% | |
| 6 | 688 | 0.8% | |
| 7 | 399 | 0.5% | |
| 10 | 374 | 0.5% | |
| 8 | 251 | 0.3% | |
| Other values (31) | 3124 | 3.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 40010 | 48.2% | |
| 1 | 25400 | 30.6% | |
| 2 | 6715 | 8.1% | |
| 3 | 3646 | 4.4% | |
| 4 | 1633 | 2.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 95 | 198 | 0.2% | |
| 90 | 93 | 0.1% | |
| 72 | 72 | 0.1% | |
| 49 | 49 | 0.1% | |
| 44 | 48 | 0.1% |
calculated_host_listings_count_shared_rooms
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.06050529512 |
|---|---|
| Minimum | 0 |
| Maximum | 23 |
| Zeros (%) | 98.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 23 |
| Range | 23 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.849479943 |
|---|---|
| Coef of variation | 14.039762 |
| Kurtosis | 449.8743391 |
| Mean | 0.06050529512 |
| MAD | 0.1193047989 |
| Skewness | 19.92249922 |
| Sum | 5022 |
| Variance | 0.7216161736 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 0 | 81831 | 98.6% | |
| 1 | 708 | 0.9% | |
| 2 | 54 | 0.1% | |
| 23 | 47 | 0.1% | |
| 18 | 46 | 0.1% | |
| 12 | 40 | < 0.1% | |
| 3 | 39 | < 0.1% | |
| 8 | 38 | < 0.1% | |
| 4 | 37 | < 0.1% | |
| 10 | 34 | < 0.1% | |
| Other values (5) | 127 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 81831 | 98.6% | |
| 1 | 708 | 0.9% | |
| 2 | 54 | 0.1% | |
| 3 | 39 | < 0.1% | |
| 4 | 37 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 23 | 47 | 0.1% | |
| 18 | 46 | 0.1% | |
| 12 | 40 | < 0.1% | |
| 11 | 12 | < 0.1% | |
| 10 | 34 | < 0.1% |
cleaning_fee
Numeric
| Distinct count | 247 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 31.61234202 |
|---|---|
| Minimum | 0 |
| Maximum | 850 |
| Zeros (%) | 32.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 20 |
| Q3 | 49 |
| 95-th percentile | 100 |
| Maximum | 850 |
| Range | 850 |
| Interquartile range | 49 |
Descriptive statistics
| Standard deviation | 42.97040263 |
|---|---|
| Coef of variation | 1.359291969 |
| Kurtosis | 20.43396555 |
| Mean | 31.61234202 |
| MAD | 29.27411487 |
| Skewness | 3.30873087 |
| Sum | 2623856 |
| Variance | 1846.455503 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 0 | 27272 | 32.9% | |
| 20 | 5116 | 6.2% | |
| 30 | 4997 | 6.0% | |
| 10 | 4419 | 5.3% | |
| 50 | 3862 | 4.7% | |
| 15 | 3633 | 4.4% | |
| 40 | 3594 | 4.3% | |
| 25 | 3150 | 3.8% | |
| 60 | 2534 | 3.1% | |
| 35 | 1877 | 2.3% | |
| Other values (237) | 22547 | 27.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 27272 | 32.9% | |
| 4 | 316 | 0.4% | |
| 5 | 1542 | 1.9% | |
| 6 | 211 | 0.3% | |
| 7 | 264 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 850 | 1 | < 0.1% | |
| 660 | 1 | < 0.1% | |
| 614 | 1 | < 0.1% | |
| 610 | 1 | < 0.1% | |
| 600 | 2 | < 0.1% |
df_index
Numeric
| Distinct count | 83001 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 42140.9591 |
|---|---|
| Minimum | 0 |
| Maximum | 83849 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4150 |
| Q1 | 21513 |
| Median | 42346 |
| Q3 | 63098 |
| 95-th percentile | 79699 |
| Maximum | 83849 |
| Range | 83849 |
| Interquartile range | 41585 |
Descriptive statistics
| Standard deviation | 24232.47157 |
|---|---|
| Coef of variation | 0.5750336986 |
| Kurtosis | -1.195572242 |
| Mean | 42140.9591 |
| MAD | 20957.60718 |
| Skewness | -0.01987690692 |
| Sum | 3497741746 |
| Variance | 587212678.5 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 70327 | 1 | < 0.1% | |
| 2708 | 1 | < 0.1% | |
| 661 | 1 | < 0.1% | |
| 6806 | 1 | < 0.1% | |
| 4759 | 1 | < 0.1% | |
| 27288 | 1 | < 0.1% | |
| 25241 | 1 | < 0.1% | |
| 31386 | 1 | < 0.1% | |
| 29339 | 1 | < 0.1% | |
| Other values (82991) | 82991 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 83849 | 1 | < 0.1% | |
| 83848 | 1 | < 0.1% | |
| 83847 | 1 | < 0.1% | |
| 83846 | 1 | < 0.1% | |
| 83845 | 1 | < 0.1% |
experiences_offered
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| none | |
|---|---|
| business | 606 |
| family | 508 |
| Other values (2) | 676 |
| Value | Count | Frequency (%) | |
| none | 81211 | 97.8% | |
| business | 606 | 0.7% | |
| family | 508 | 0.6% | |
| social | 452 | 0.5% | |
| romantic | 224 | 0.3% |
| Max length | 8 |
|---|---|
| Mean length | 4.063131769 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
extra_people
Numeric
| Distinct count | 105 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7.450669269 |
|---|---|
| Minimum | 0 |
| Maximum | 239 |
| Zeros (%) | 61.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 10 |
| 95-th percentile | 30 |
| Maximum | 239 |
| Range | 239 |
| Interquartile range | 10 |
Descriptive statistics
| Standard deviation | 14.00717298 |
|---|---|
| Coef of variation | 1.879988558 |
| Kurtosis | 48.3762008 |
| Mean | 7.450669269 |
| MAD | 9.271163573 |
| Skewness | 4.921974547 |
| Sum | 618413 |
| Variance | 196.2008948 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 0 | 50746 | 61.1% | |
| 10 | 7738 | 9.3% | |
| 15 | 6362 | 7.7% | |
| 20 | 4768 | 5.7% | |
| 25 | 2267 | 2.7% | |
| 5 | 2079 | 2.5% | |
| 30 | 1666 | 2.0% | |
| 50 | 1045 | 1.3% | |
| 12 | 637 | 0.8% | |
| 35 | 627 | 0.8% | |
| Other values (95) | 5066 | 6.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 50746 | 61.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 309 | 0.4% | |
| 5 | 2079 | 2.5% | |
| 6 | 223 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 239 | 1 | < 0.1% | |
| 236 | 1 | < 0.1% | |
| 235 | 4 | < 0.1% | |
| 233 | 1 | < 0.1% | |
| 232 | 1 | < 0.1% |
guests_included
Numeric
| Distinct count | 17 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.610715534 |
|---|---|
| Minimum | 1 |
| Maximum | 22 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 22 |
| Range | 21 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.348327074 |
|---|---|
| Coef of variation | 0.8370982002 |
| Kurtosis | 15.67421192 |
| Mean | 1.610715534 |
| MAD | 0.8837168039 |
| Skewness | 3.31576737 |
| Sum | 133691 |
| Variance | 1.817985899 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 1 | 60052 | 72.4% | |
| 2 | 12598 | 15.2% | |
| 4 | 5315 | 6.4% | |
| 3 | 1580 | 1.9% | |
| 6 | 1579 | 1.9% | |
| 5 | 886 | 1.1% | |
| 8 | 449 | 0.5% | |
| 7 | 249 | 0.3% | |
| 10 | 117 | 0.1% | |
| 9 | 78 | 0.1% | |
| Other values (7) | 98 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 60052 | 72.4% | |
| 2 | 12598 | 15.2% | |
| 3 | 1580 | 1.9% | |
| 4 | 5315 | 6.4% | |
| 5 | 886 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 22 | 1 | < 0.1% | |
| 16 | 29 | < 0.1% | |
| 15 | 12 | < 0.1% | |
| 14 | 7 | < 0.1% | |
| 13 | 1 | < 0.1% |
host_id
Numeric
| Distinct count | 52739 |
|---|---|
| Unique (%) | 63.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 78575511.92 |
|---|---|
| Minimum | 2010 |
| Maximum | 274979066 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2010 |
|---|---|
| 5-th percentile | 1849921 |
| Q1 | 14510588 |
| Median | 44556133 |
| Q3 | 133680018 |
| 95-th percentile | 241034482 |
| Maximum | 274979066 |
| Range | 274977056 |
| Interquartile range | 119169430 |
Descriptive statistics
| Standard deviation | 78499274.18 |
|---|---|
| Coef of variation | 0.9990297519 |
| Kurtosis | -0.3535694039 |
| Mean | 78575511.92 |
| MAD | 66559211.81 |
| Skewness | 0.9444207288 |
| Sum | 6.521846065e+12 |
| Variance | 6.162136047e+15 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 33889201 | 1138 | 1.4% | |
| 156158778 | 263 | 0.3% | |
| 28820321 | 209 | 0.3% | |
| 137094377 | 177 | 0.2% | |
| 48165024 | 164 | 0.2% | |
| 1432477 | 160 | 0.2% | |
| 27572615 | 134 | 0.2% | |
| 224866971 | 114 | 0.1% | |
| 50291093 | 113 | 0.1% | |
| 83740964 | 102 | 0.1% | |
| Other values (52729) | 80427 | 96.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2010 | 1 | < 0.1% | |
| 2697 | 1 | < 0.1% | |
| 4775 | 7 | < 0.1% | |
| 5653 | 1 | < 0.1% | |
| 6774 | 3 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 274979066 | 1 | < 0.1% | |
| 274953295 | 1 | < 0.1% | |
| 274950405 | 1 | < 0.1% | |
| 274946144 | 1 | < 0.1% | |
| 274944036 | 1 | < 0.1% |
host_listings_count
Highly correlated
This variable is highly correlated with calculated_host_listings_count_entire_homes and should be ignored for analysis
| Correlation | 0.9820095924 |
|---|
host_response_rate
Numeric
| Distinct count | 79 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 29.3% |
| Missing (n) | 24307 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 93.13234743 |
|---|---|
| Minimum | 0 |
| Maximum | 100 |
| Zeros (%) | 1.3% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 60 |
| Q1 | 96 |
| Median | 100 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 17.37685787 |
|---|---|
| Coef of variation | 0.1865824104 |
| Kurtosis | 15.30808278 |
| Mean | 93.13234743 |
| MAD | 9.952461339 |
| Skewness | -3.762046953 |
| Sum | 5466310 |
| Variance | 301.9551893 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 100 | 39036 | 47.0% | |
| 90 | 2140 | 2.6% | |
| 96 | 1829 | 2.2% | |
| 80 | 1385 | 1.7% | |
| 99 | 1371 | 1.7% | |
| 0 | 1097 | 1.3% | |
| 97 | 1080 | 1.3% | |
| 98 | 1039 | 1.3% | |
| 50 | 752 | 0.9% | |
| 89 | 679 | 0.8% | |
| Other values (68) | 8286 | 10.0% | |
| (Missing) | 24307 | 29.3% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1097 | 1.3% | |
| 7 | 1 | < 0.1% | |
| 9 | 7 | < 0.1% | |
| 10 | 13 | < 0.1% | |
| 11 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 100 | 39036 | 47.0% | |
| 99 | 1371 | 1.7% | |
| 98 | 1039 | 1.3% | |
| 97 | 1080 | 1.3% | |
| 96 | 1829 | 2.2% |
host_total_listings_count
Highly correlated
This variable is highly correlated with host_listings_count and should be ignored for analysis
| Correlation | 1 |
|---|
latitude
Numeric
| Distinct count | 20464 |
|---|---|
| Unique (%) | 24.7% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 51.50948047 |
|---|---|
| Minimum | 51.29272 |
| Maximum | 51.68657 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 51.29272 |
|---|---|
| 5-th percentile | 51.42477 |
| Q1 | 51.4853 |
| Median | 51.51395 |
| Q3 | 51.53731 |
| 95-th percentile | 51.58339 |
| Maximum | 51.68657 |
| Range | 0.39385 |
| Interquartile range | 0.05201 |
Descriptive statistics
| Standard deviation | 0.04620385519 |
|---|---|
| Coef of variation | 0.0008969971113 |
| Kurtosis | 0.9481528856 |
| Mean | 51.50948047 |
| MAD | 0.03507655089 |
| Skewness | -0.3341730115 |
| Sum | 4275338.388 |
| Variance | 0.002134796234 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 51.51571 | 23 | < 0.1% | |
| 51.51682 | 23 | < 0.1% | |
| 51.51516 | 22 | < 0.1% | |
| 51.52559 | 21 | < 0.1% | |
| 51.51508 | 21 | < 0.1% | |
| 51.51264 | 21 | < 0.1% | |
| 51.4933 | 21 | < 0.1% | |
| 51.51652 | 21 | < 0.1% | |
| 51.52486 | 21 | < 0.1% | |
| 51.49851 | 20 | < 0.1% | |
| Other values (20454) | 82787 | 99.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 51.29272 | 1 | < 0.1% | |
| 51.29454 | 1 | < 0.1% | |
| 51.29479 | 1 | < 0.1% | |
| 51.29712 | 1 | < 0.1% | |
| 51.29733 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 51.68657 | 1 | < 0.1% | |
| 51.68169 | 1 | < 0.1% | |
| 51.67984 | 1 | < 0.1% | |
| 51.6792 | 1 | < 0.1% | |
| 51.67651 | 1 | < 0.1% |
longitude
Numeric
| Distinct count | 31565 |
|---|---|
| Unique (%) | 38.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | -0.1283144238 |
|---|---|
| Minimum | -0.5013 |
| Maximum | 0.29657 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | -0.5013 |
|---|---|
| 5-th percentile | -0.28271 |
| Q1 | -0.18828 |
| Median | -0.12576 |
| Q3 | -0.07036 |
| 95-th percentile | 0.01337 |
| Maximum | 0.29657 |
| Range | 0.79787 |
| Interquartile range | 0.11792 |
Descriptive statistics
| Standard deviation | 0.09219373613 |
|---|---|
| Coef of variation | -0.7184986177 |
| Kurtosis | 1.192943761 |
| Mean | -0.1283144238 |
| MAD | 0.07088540533 |
| Skewness | -0.1363595077 |
| Sum | -10650.22549 |
| Variance | 0.008499684983 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| -0.07057 | 15 | < 0.1% | |
| -0.0718 | 13 | < 0.1% | |
| -0.09728 | 13 | < 0.1% | |
| -0.13472 | 13 | < 0.1% | |
| -0.1648 | 13 | < 0.1% | |
| -0.07255 | 12 | < 0.1% | |
| -0.07448 | 12 | < 0.1% | |
| -0.19255 | 12 | < 0.1% | |
| -0.07015 | 12 | < 0.1% | |
| -0.19517 | 12 | < 0.1% | |
| Other values (31555) | 82874 | 99.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| -0.5013 | 1 | < 0.1% | |
| -0.49918 | 1 | < 0.1% | |
| -0.49582 | 1 | < 0.1% | |
| -0.49509 | 1 | < 0.1% | |
| -0.48786 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 0.29657 | 1 | < 0.1% | |
| 0.28774 | 1 | < 0.1% | |
| 0.28539 | 1 | < 0.1% | |
| 0.28429 | 1 | < 0.1% | |
| 0.27268 | 1 | < 0.1% |
neighbourhood_cleansed
Categorical
| Distinct count | 33 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Westminster | 9333 |
|---|---|
| Tower Hamlets | 7958 |
| Hackney | 6040 |
| Other values (30) |
| Value | Count | Frequency (%) | |
| Westminster | 9333 | 11.2% | |
| Tower Hamlets | 7958 | 9.6% | |
| Hackney | 6040 | 7.3% | |
| Camden | 5913 | 7.1% | |
| Kensington and Chelsea | 5802 | 7.0% | |
| Islington | 5100 | 6.1% | |
| Southwark | 4842 | 5.8% | |
| Lambeth | 4761 | 5.7% | |
| Wandsworth | 4208 | 5.1% | |
| Hammersmith and Fulham | 4155 | 5.0% | |
| Other values (23) | 24889 | 30.0% |
| Max length | 22 |
|---|---|
| Mean length | 10.61882387 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
number_of_reviews
Numeric
| Distinct count | 394 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 16.49200612 |
|---|---|
| Minimum | 0 |
| Maximum | 665 |
| Zeros (%) | 25.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 4 |
| Q3 | 17 |
| 95-th percentile | 75 |
| Maximum | 665 |
| Range | 665 |
| Interquartile range | 17 |
Descriptive statistics
| Standard deviation | 34.92925879 |
|---|---|
| Coef of variation | 2.117950875 |
| Kurtosis | 39.26389222 |
| Mean | 16.49200612 |
| MAD | 19.33499945 |
| Skewness | 5.074501643 |
| Sum | 1368853 |
| Variance | 1220.05312 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 0 | 20792 | 25.1% | |
| 1 | 8917 | 10.7% | |
| 2 | 5735 | 6.9% | |
| 3 | 4472 | 5.4% | |
| 4 | 3474 | 4.2% | |
| 5 | 2777 | 3.3% | |
| 6 | 2343 | 2.8% | |
| 7 | 2056 | 2.5% | |
| 8 | 1724 | 2.1% | |
| 9 | 1669 | 2.0% | |
| Other values (384) | 29042 | 35.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 20792 | 25.1% | |
| 1 | 8917 | 10.7% | |
| 2 | 5735 | 6.9% | |
| 3 | 4472 | 5.4% | |
| 4 | 3474 | 4.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 665 | 1 | < 0.1% | |
| 598 | 1 | < 0.1% | |
| 589 | 1 | < 0.1% | |
| 579 | 1 | < 0.1% | |
| 578 | 1 | < 0.1% |
number_of_reviews_ltm
Numeric
| Distinct count | 148 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.702268647 |
|---|---|
| Minimum | 0 |
| Maximum | 200 |
| Zeros (%) | 40.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 8 |
| 95-th percentile | 31 |
| Maximum | 200 |
| Range | 200 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 12.64576431 |
|---|---|
| Coef of variation | 1.886788635 |
| Kurtosis | 19.60888575 |
| Mean | 6.702268647 |
| MAD | 7.894171309 |
| Skewness | 3.682787627 |
| Sum | 556295 |
| Variance | 159.915355 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 0 | 33561 | 40.4% | |
| 1 | 8087 | 9.7% | |
| 2 | 5455 | 6.6% | |
| 3 | 4214 | 5.1% | |
| 4 | 3374 | 4.1% | |
| 5 | 2670 | 3.2% | |
| 6 | 2347 | 2.8% | |
| 7 | 2067 | 2.5% | |
| 8 | 1763 | 2.1% | |
| 9 | 1616 | 1.9% | |
| Other values (138) | 17847 | 21.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 33561 | 40.4% | |
| 1 | 8087 | 9.7% | |
| 2 | 5455 | 6.6% | |
| 3 | 4214 | 5.1% | |
| 4 | 3374 | 4.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 200 | 1 | < 0.1% | |
| 191 | 1 | < 0.1% | |
| 180 | 1 | < 0.1% | |
| 176 | 1 | < 0.1% | |
| 165 | 1 | < 0.1% |
price
Numeric
| Distinct count | 911 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 121.9246515 |
|---|---|
| Minimum | 0 |
| Maximum | 13700 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 25 |
| Q1 | 45 |
| Median | 82 |
| Q3 | 140 |
| 95-th percentile | 320 |
| Maximum | 13700 |
| Range | 13700 |
| Interquartile range | 95 |
Descriptive statistics
| Standard deviation | 225.8462003 |
|---|---|
| Coef of variation | 1.85234239 |
| Kurtosis | 1030.278324 |
| Mean | 121.9246515 |
| MAD | 82.30763758 |
| Skewness | 25.10330353 |
| Sum | 10119868 |
| Variance | 51006.5062 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 50 | 3091 | 3.7% | |
| 100 | 2923 | 3.5% | |
| 40 | 2689 | 3.2% | |
| 35 | 2434 | 2.9% | |
| 45 | 2311 | 2.8% | |
| 30 | 2303 | 2.8% | |
| 120 | 2266 | 2.7% | |
| 150 | 2194 | 2.6% | |
| 60 | 2190 | 2.6% | |
| 80 | 2156 | 2.6% | |
| Other values (901) | 58444 | 70.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 19 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 7 | 5 | < 0.1% | |
| 8 | 27 | < 0.1% | |
| 9 | 4 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 13700 | 1 | < 0.1% | |
| 12345 | 4 | < 0.1% | |
| 10000 | 2 | < 0.1% | |
| 9999 | 3 | < 0.1% | |
| 8000 | 1 | < 0.1% |
property_type
Categorical
| Distinct count | 40 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Apartment | |
|---|---|
| House | |
| Townhouse | 2943 |
| Other values (37) | 6594 |
| Value | Count | Frequency (%) | |
| Apartment | 56267 | 67.8% | |
| House | 17197 | 20.7% | |
| Townhouse | 2943 | 3.5% | |
| Serviced apartment | 1890 | 2.3% | |
| Condominium | 1099 | 1.3% | |
| Bed and breakfast | 872 | 1.1% | |
| Loft | 711 | 0.9% | |
| Guest suite | 355 | 0.4% | |
| Guesthouse | 279 | 0.3% | |
| Hostel | 227 | 0.3% | |
| Other values (30) | 1161 | 1.4% |
| Max length | 22 |
|---|---|
| Mean length | 8.435344152 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
review_scores_accuracy
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 27.1% |
| Missing (n) | 22485 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.518408355 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 9 |
| Median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.973909779 |
|---|---|
| Coef of variation | 0.102318554 |
| Kurtosis | 20.03370452 |
| Mean | 9.518408355 |
| MAD | 0.6608555324 |
| Skewness | -3.724294125 |
| Sum | 576016 |
| Variance | 0.9485002577 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 10 | 41521 | 50.0% | |
| 9 | 13595 | 16.4% | |
| 8 | 3466 | 4.2% | |
| 7 | 697 | 0.8% | |
| 6 | 676 | 0.8% | |
| 2 | 277 | 0.3% | |
| 4 | 174 | 0.2% | |
| 5 | 104 | 0.1% | |
| 3 | 6 | < 0.1% | |
| (Missing) | 22485 | 27.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 277 | 0.3% | |
| 3 | 6 | < 0.1% | |
| 4 | 174 | 0.2% | |
| 5 | 104 | 0.1% | |
| 6 | 676 | 0.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 41521 | 50.0% | |
| 9 | 13595 | 16.4% | |
| 8 | 3466 | 4.2% | |
| 7 | 697 | 0.8% | |
| 6 | 676 | 0.8% |
review_scores_checkin
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 27.2% |
| Missing (n) | 22537 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.633103996 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 10 |
| Median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.8935611894 |
|---|---|
| Coef of variation | 0.09275942519 |
| Kurtosis | 27.21963505 |
| Mean | 9.633103996 |
| MAD | 0.5602834026 |
| Skewness | -4.407604451 |
| Sum | 582456 |
| Variance | 0.7984515992 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 10 | 46167 | 55.6% | |
| 9 | 10296 | 12.4% | |
| 8 | 2460 | 3.0% | |
| 7 | 544 | 0.7% | |
| 6 | 541 | 0.7% | |
| 2 | 251 | 0.3% | |
| 4 | 129 | 0.2% | |
| 5 | 71 | 0.1% | |
| 3 | 5 | < 0.1% | |
| (Missing) | 22537 | 27.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 251 | 0.3% | |
| 3 | 5 | < 0.1% | |
| 4 | 129 | 0.2% | |
| 5 | 71 | 0.1% | |
| 6 | 541 | 0.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 46167 | 55.6% | |
| 9 | 10296 | 12.4% | |
| 8 | 2460 | 3.0% | |
| 7 | 544 | 0.7% | |
| 6 | 541 | 0.7% |
review_scores_cleanliness
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 27.1% |
| Missing (n) | 22474 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.28640111 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 9 |
| Median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.119944107 |
|---|---|
| Coef of variation | 0.1206004451 |
| Kurtosis | 11.24120513 |
| Mean | 9.28640111 |
| MAD | 0.8012321864 |
| Skewness | -2.749221146 |
| Sum | 562078 |
| Variance | 1.254274803 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 10 | 33980 | 40.9% | |
| 9 | 17024 | 20.5% | |
| 8 | 6217 | 7.5% | |
| 7 | 1510 | 1.8% | |
| 6 | 1010 | 1.2% | |
| 2 | 307 | 0.4% | |
| 4 | 283 | 0.3% | |
| 5 | 181 | 0.2% | |
| 3 | 15 | < 0.1% | |
| (Missing) | 22474 | 27.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 307 | 0.4% | |
| 3 | 15 | < 0.1% | |
| 4 | 283 | 0.3% | |
| 5 | 181 | 0.2% | |
| 6 | 1010 | 1.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 33980 | 40.9% | |
| 9 | 17024 | 20.5% | |
| 8 | 6217 | 7.5% | |
| 7 | 1510 | 1.8% | |
| 6 | 1010 | 1.2% |
review_scores_communication
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 27.1% |
| Missing (n) | 22482 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.664353344 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 10 |
| Median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.8795104364 |
|---|---|
| Coef of variation | 0.09100561674 |
| Kurtosis | 29.34634106 |
| Mean | 9.664353344 |
| MAD | 0.5297004389 |
| Skewness | -4.632967078 |
| Sum | 584877 |
| Variance | 0.7735386078 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 10 | 47754 | 57.5% | |
| 9 | 9035 | 10.9% | |
| 8 | 2231 | 2.7% | |
| 7 | 527 | 0.6% | |
| 6 | 516 | 0.6% | |
| 2 | 243 | 0.3% | |
| 4 | 148 | 0.2% | |
| 5 | 58 | 0.1% | |
| 3 | 7 | < 0.1% | |
| (Missing) | 22482 | 27.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 243 | 0.3% | |
| 3 | 7 | < 0.1% | |
| 4 | 148 | 0.2% | |
| 5 | 58 | 0.1% | |
| 6 | 516 | 0.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 47754 | 57.5% | |
| 9 | 9035 | 10.9% | |
| 8 | 2231 | 2.7% | |
| 7 | 527 | 0.6% | |
| 6 | 516 | 0.6% |
review_scores_location
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 27.2% |
| Missing (n) | 22536 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.524981394 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 9 |
| Median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.8267743115 |
|---|---|
| Coef of variation | 0.08680062221 |
| Kurtosis | 19.58672382 |
| Mean | 9.524981394 |
| MAD | 0.614660642 |
| Skewness | -3.324764529 |
| Sum | 575928 |
| Variance | 0.6835557622 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 10 | 39120 | 47.1% | |
| 9 | 16601 | 20.0% | |
| 8 | 3595 | 4.3% | |
| 6 | 484 | 0.6% | |
| 7 | 409 | 0.5% | |
| 2 | 133 | 0.2% | |
| 4 | 87 | 0.1% | |
| 5 | 35 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| (Missing) | 22536 | 27.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 133 | 0.2% | |
| 3 | 1 | < 0.1% | |
| 4 | 87 | 0.1% | |
| 5 | 35 | < 0.1% | |
| 6 | 484 | 0.6% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 39120 | 47.1% | |
| 9 | 16601 | 20.0% | |
| 8 | 3595 | 4.3% | |
| 7 | 409 | 0.5% | |
| 6 | 484 | 0.6% |
review_scores_rating
Numeric
| Distinct count | 59 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 27.0% |
| Missing (n) | 22434 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 92.74043621 |
|---|---|
| Minimum | 20 |
| Maximum | 100 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 78 |
| Q1 | 90 |
| Median | 96 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 80 |
| Interquartile range | 10 |
Descriptive statistics
| Standard deviation | 9.957765382 |
|---|---|
| Coef of variation | 0.1073724234 |
| Kurtosis | 15.64786751 |
| Mean | 92.74043621 |
| MAD | 6.62188899 |
| Skewness | -3.187230575 |
| Sum | 5617010 |
| Variance | 99.1570914 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 100 | 17458 | 21.0% | |
| 98 | 3868 | 4.7% | |
| 93 | 3655 | 4.4% | |
| 96 | 3608 | 4.3% | |
| 97 | 3559 | 4.3% | |
| 95 | 3328 | 4.0% | |
| 90 | 3188 | 3.8% | |
| 80 | 3183 | 3.8% | |
| 99 | 2429 | 2.9% | |
| 94 | 2270 | 2.7% | |
| Other values (48) | 14021 | 16.9% | |
| (Missing) | 22434 | 27.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 20 | 271 | 0.3% | |
| 30 | 7 | < 0.1% | |
| 33 | 1 | < 0.1% | |
| 35 | 1 | < 0.1% | |
| 40 | 196 | 0.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 100 | 17458 | 21.0% | |
| 99 | 2429 | 2.9% | |
| 98 | 3868 | 4.7% | |
| 97 | 3559 | 4.3% | |
| 96 | 3608 | 4.3% |
review_scores_value
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 27.2% |
| Missing (n) | 22535 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 9.283332782 |
|---|---|
| Minimum | 2 |
| Maximum | 10 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 9 |
| Median | 10 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 8 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.025273471 |
|---|---|
| Coef of variation | 0.1104423912 |
| Kurtosis | 14.0169692 |
| Mean | 9.283332782 |
| MAD | 0.7254616987 |
| Skewness | -2.92321941 |
| Sum | 561326 |
| Variance | 1.051185691 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 10 | 30604 | 36.9% | |
| 9 | 21903 | 26.4% | |
| 8 | 5555 | 6.7% | |
| 7 | 955 | 1.2% | |
| 6 | 840 | 1.0% | |
| 2 | 275 | 0.3% | |
| 4 | 204 | 0.2% | |
| 5 | 119 | 0.1% | |
| 3 | 11 | < 0.1% | |
| (Missing) | 22535 | 27.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 2 | 275 | 0.3% | |
| 3 | 11 | < 0.1% | |
| 4 | 204 | 0.2% | |
| 5 | 119 | 0.1% | |
| 6 | 840 | 1.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 30604 | 36.9% | |
| 9 | 21903 | 26.4% | |
| 8 | 5555 | 6.7% | |
| 7 | 955 | 1.2% | |
| 6 | 840 | 1.0% |
reviews_per_month
Numeric
| Distinct count | 939 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 25.0% |
| Missing (n) | 20791 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.214102556 |
|---|---|
| Minimum | 0 |
| Maximum | 30.93 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.05 |
| Q1 | 0.25 |
| Median | 0.75 |
| Q3 | 1.65 |
| 95-th percentile | 4.07 |
| Maximum | 30.93 |
| Range | 30.93 |
| Interquartile range | 1.4 |
Descriptive statistics
| Standard deviation | 1.419411363 |
|---|---|
| Coef of variation | 1.169103348 |
| Kurtosis | 10.78112772 |
| Mean | 1.214102556 |
| MAD | 1.004085061 |
| Skewness | 2.471008393 |
| Sum | 75529.32 |
| Variance | 2.014728617 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 1 | 2032 | 2.4% | |
| 0.08 | 1000 | 1.2% | |
| 0.16 | 955 | 1.2% | |
| 0.04 | 942 | 1.1% | |
| 0.05 | 932 | 1.1% | |
| 0.09 | 897 | 1.1% | |
| 0.03 | 861 | 1.0% | |
| 2 | 808 | 1.0% | |
| 0.02 | 804 | 1.0% | |
| 0.06 | 784 | 0.9% | |
| Other values (928) | 52195 | 62.9% | |
| (Missing) | 20791 | 25.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 0.01 | 37 | < 0.1% | |
| 0.02 | 804 | 1.0% | |
| 0.03 | 861 | 1.0% | |
| 0.04 | 942 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 30.93 | 1 | < 0.1% | |
| 17.03 | 1 | < 0.1% | |
| 15 | 1 | < 0.1% | |
| 14.64 | 2 | < 0.1% | |
| 14.63 | 1 | < 0.1% |
room_type
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Entire home/apt | |
|---|---|
| Private room | |
| Shared room | 725 |
| Value | Count | Frequency (%) | |
| Entire home/apt | 46694 | 56.3% | |
| Private room | 35582 | 42.9% | |
| Shared room | 725 | 0.9% |
| Max length | 15 |
|---|---|
| Mean length | 13.67897977 |
| Min length | 11 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
security_deposit
Numeric
| Distinct count | 382 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 130.8046289 |
|---|---|
| Minimum | 0 |
| Maximum | 17995 |
| Zeros (%) | 57.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 200 |
| 95-th percentile | 500 |
| Maximum | 17995 |
| Range | 17995 |
| Interquartile range | 200 |
Descriptive statistics
| Standard deviation | 282.6378046 |
|---|---|
| Coef of variation | 2.160763018 |
| Kurtosis | 244.9812768 |
| Mean | 130.8046289 |
| MAD | 160.1246022 |
| Skewness | 8.606064364 |
| Sum | 10856915 |
| Variance | 79884.12858 |
| Memory size | 648.6 KiB |
| Value | Count | Frequency (%) | |
| 0 | 47852 | 57.7% | |
| 100 | 5796 | 7.0% | |
| 200 | 4925 | 5.9% | |
| 250 | 3476 | 4.2% | |
| 300 | 3232 | 3.9% | |
| 500 | 3177 | 3.8% | |
| 150 | 2844 | 3.4% | |
| 85 | 1831 | 2.2% | |
| 495 | 1289 | 1.6% | |
| 1000 | 1073 | 1.3% | |
| Other values (372) | 7506 | 9.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 47852 | 57.7% | |
| 56 | 1 | < 0.1% | |
| 57 | 1 | < 0.1% | |
| 60 | 18 | < 0.1% | |
| 61 | 6 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 17995 | 1 | < 0.1% | |
| 4098 | 1 | < 0.1% | |
| 4040 | 1 | < 0.1% | |
| 4003 | 1 | < 0.1% | |
| 4000 | 2 | < 0.1% |
zipcode
Categorical
| Distinct count | 33819 |
|---|---|
| Unique (%) | 40.7% |
| Missing (%) | 2.3% |
| Missing (n) | 1947 |
| E1 | 451 |
|---|---|
| SE1 | 400 |
| NW1 | 366 |
| Other values (33815) | |
| (Missing) | 1947 |
| Value | Count | Frequency (%) | |
| E1 | 451 | 0.5% | |
| SE1 | 400 | 0.5% | |
| NW1 | 366 | 0.4% | |
| N1 | 349 | 0.4% | |
| E2 | 329 | 0.4% | |
| W2 | 304 | 0.4% | |
| E14 | 263 | 0.3% | |
| SW6 | 199 | 0.2% | |
| SW11 | 175 | 0.2% | |
| E3 | 153 | 0.2% | |
| Other values (33808) | 78065 | 94.1% | |
| (Missing) | 1947 | 2.3% |
| Max length | 22 |
|---|---|
| Mean length | 6.360031807 |
| Min length | 1 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | True |
| Contains non-words | True |
First rows
| accommodates | amenities | bathrooms | bed_type | bedrooms | beds | calculated_host_listings_count | calculated_host_listings_count_entire_homes | calculated_host_listings_count_private_rooms | calculated_host_listings_count_shared_rooms | cleaning_fee | df_index | experiences_offered | extra_people | guests_included | host_id | host_listings_count | host_response_rate | host_total_listings_count | latitude | longitude | neighbourhood_cleansed | number_of_reviews | number_of_reviews_ltm | price | property_type | review_scores_accuracy | review_scores_checkin | review_scores_cleanliness | review_scores_communication | review_scores_location | review_scores_rating | review_scores_value | reviews_per_month | room_type | security_deposit | zipcode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2 | {TV,"Cable TV",Wifi,Kitchen,"Paid parking off premises","Smoking allowed","Free street parking","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Outlet covers",Bathtub,"Children’s books and toys","Babysitter recommendations",Crib,"Pack ’n Play/travel crib","Room-darkening shades","Children’s dinnerware","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection","Coffee maker",Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Patio or balcony","Luggage dropoff allowed","Long term stays allowed","No stairs or steps to enter","Wide entrance","Extra space around bed","Accessible-height bed","No stairs or steps to enter","Wide doorway to guest bathroom","Bathtub with bath chair","Accessible-height toilet","Host greets you","Handheld shower head","Roll-in shower"} | 1.0 | Real Bed | 1.0 | 0.0 | 3 | 1 | 2 | 0 | 15.0 | 0 | business | 15.0 | 1 | 54730 | 4.0 | 86.0 | 4.0 | 51.56802 | -0.11121 | Islington | 16 | 2 | 65.0 | Apartment | 9.0 | 9.0 | 10.0 | 10.0 | 9.0 | 96.0 | 9.0 | 0.15 | Private room | 100.0 | N4 3 |
| 1 | 2 | {TV,"Cable TV",Internet,Wifi,"Air conditioning",Kitchen,"Buzzer/wireless intercom",Heating,Washer,Dryer,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Hot water","Luggage dropoff allowed","Long term stays allowed",Other} | 1.0 | Real Bed | 1.0 | 1.0 | 1 | 1 | 0 | 0 | 50.0 | 1 | romantic | 0.0 | 2 | 60302 | 1.0 | 100.0 | 1.0 | 51.48796 | -0.16898 | Kensington and Chelsea | 85 | 4 | 100.0 | Apartment | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 96.0 | 9.0 | 0.73 | Entire home/apt | 150.0 | SW3 |
| 2 | 6 | {TV,Wifi,Kitchen,"Paid parking off premises",Elevator,"Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Hot water","Bed linens",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Long term stays allowed"} | 2.0 | Real Bed | 3.0 | 3.0 | 14 | 14 | 0 | 0 | 65.0 | 2 | none | 10.0 | 4 | 67564 | 19.0 | 85.0 | 19.0 | 51.52098 | -0.14002 | Westminster | 41 | 12 | 300.0 | Apartment | 10.0 | 9.0 | 9.0 | 9.0 | 10.0 | 94.0 | 9.0 | 0.41 | Entire home/apt | 350.0 | W1T4BP |
| 3 | 2 | {TV,"Cable TV",Internet,Wifi,Kitchen,"Free parking on premises","Pets allowed","Pets live on this property","Indoor fireplace",Heating,"Family/kid friendly",Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in",Lockbox,"Hot water","Long term stays allowed"} | 1.5 | Real Bed | 1.0 | 1.0 | 1 | 1 | 0 | 0 | 70.0 | 3 | family | 0.0 | 2 | 41759 | 2.0 | 100.0 | 2.0 | 51.47298 | -0.16376 | Wandsworth | 93 | 1 | 175.0 | Townhouse | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 98.0 | 9.0 | 0.88 | Entire home/apt | 250.0 | SW11 5GX |
| 4 | 4 | {TV,Wifi,Kitchen,"Free parking on premises",Elevator,"Buzzer/wireless intercom",Heating,Washer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50","Hot water","Host greets you"} | 1.0 | Real Bed | 2.0 | 2.0 | 1 | 1 | 0 | 0 | 50.0 | 4 | none | 11.0 | 2 | 102813 | 1.0 | 100.0 | 1.0 | 51.44687 | -0.21874 | Wandsworth | 28 | 3 | 65.0 | Apartment | 10.0 | 9.0 | 9.0 | 9.0 | 9.0 | 91.0 | 9.0 | 0.69 | Entire home/apt | 250.0 | SW19 6QH |
| 5 | 2 | {Wifi,Kitchen,"Buzzer/wireless intercom",Heating,Washer,"Smoke detector",Essentials,Shampoo,"Lock on bedroom door","24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","translation missing: en.hosting_amenity_49","translation missing: en.hosting_amenity_50"} | 1.5 | Real Bed | 1.0 | 1.0 | 3 | 0 | 3 | 0 | 0.0 | 5 | none | 8.0 | 1 | 103583 | 3.0 | 70.0 | 3.0 | 51.57224 | -0.20906 | Barnet | 122 | 8 | 29.0 | House | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 95.0 | 10.0 | 1.08 | Private room | 100.0 | NW11 9 |
| 6 | 4 | {TV,"Cable TV",Internet,Wifi,Kitchen,"Paid parking off premises","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Outlet covers",Bathtub,"High chair","Children’s books and toys",Crib,"Pack ’n Play/travel crib","Children’s dinnerware","Hot water","Bed linens","Extra pillows and blankets","Luggage dropoff allowed","Long term stays allowed","Host greets you"} | 1.0 | Real Bed | 1.0 | 3.0 | 5 | 5 | 0 | 0 | 75.0 | 6 | none | 15.0 | 3 | 110865 | 5.0 | 100.0 | 5.0 | 51.54168 | -0.10207 | Islington | 62 | 10 | 147.0 | Apartment | 8.0 | 9.0 | 9.0 | 9.0 | 9.0 | 85.0 | 8.0 | 0.59 | Entire home/apt | 100.0 | N1 2 |
| 7 | 5 | {TV,"Cable TV",Internet,Wifi,Kitchen,"Paid parking off premises","Buzzer/wireless intercom",Heating,"Family/kid friendly",Washer,"Smoke detector","Carbon monoxide detector","Fire extinguisher",Essentials,Shampoo,"24-hour check-in",Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Outlet covers",Bathtub,"High chair","Children’s books and toys",Crib,"Pack ’n Play/travel crib","Game console","Hot water","Bed linens","Extra pillows and blankets",Microwave,"Coffee maker",Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Luggage dropoff allowed","Long term stays allowed","Host greets you"} | 1.0 | Real Bed | 1.0 | 1.0 | 5 | 5 | 0 | 0 | 75.0 | 7 | none | 10.0 | 3 | 110865 | 5.0 | 100.0 | 5.0 | 51.53883 | -0.10153 | Islington | 79 | 12 | 147.0 | Apartment | 9.0 | 9.0 | 9.0 | 10.0 | 10.0 | 90.0 | 9.0 | 0.75 | Entire home/apt | 100.0 | N1 2 |
| 8 | 2 | {TV,Wifi,Kitchen,"Paid parking off premises",Breakfast,Heating,Washer,"Smoke detector","First aid kit",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"translation missing: en.hosting_amenity_50","Hot water",Microwave,Refrigerator,"Dishes and silverware","Cooking basics",Oven,Stove,"Garden or backyard","Host greets you"} | 1.5 | Real Bed | 1.0 | 1.0 | 1 | 0 | 1 | 0 | 10.0 | 8 | none | 12.0 | 1 | 134606 | 2.0 | 100.0 | 2.0 | 51.53484 | 0.02707 | Newham | 115 | 11 | 34.0 | Townhouse | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 97.0 | 10.0 | 1.05 | Private room | 0.0 | E13 0QF |
| 9 | 2 | {Wifi,Kitchen,"Pets live on this property",Cat(s),"Free street parking",Heating,Washer,Dryer,"Smoke detector",Essentials,"Self check-in","Building staff","Hot water"} | 1.0 | Real Bed | 1.0 | 1.0 | 1 | 0 | 1 | 0 | 0.0 | 9 | none | 0.0 | 1 | 144444 | 1.0 | 100.0 | 1.0 | 51.46507 | -0.32421 | Hounslow | 5 | 3 | 100.0 | House | 9.0 | 10.0 | 10.0 | 10.0 | 10.0 | 88.0 | 8.0 | 0.05 | Private room | 0.0 | TW7 7HG |
Last rows
| accommodates | amenities | bathrooms | bed_type | bedrooms | beds | calculated_host_listings_count | calculated_host_listings_count_entire_homes | calculated_host_listings_count_private_rooms | calculated_host_listings_count_shared_rooms | cleaning_fee | df_index | experiences_offered | extra_people | guests_included | host_id | host_listings_count | host_response_rate | host_total_listings_count | latitude | longitude | neighbourhood_cleansed | number_of_reviews | number_of_reviews_ltm | price | property_type | review_scores_accuracy | review_scores_checkin | review_scores_cleanliness | review_scores_communication | review_scores_location | review_scores_rating | review_scores_value | reviews_per_month | room_type | security_deposit | zipcode | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82991 | 4 | {TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Pets allowed",Elevator,Heating,Washer,Dryer,"Smoke detector","Carbon monoxide detector",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron,"Private entrance","High chair","Pack ’n Play/travel crib","Hot water","Bed linens","Extra pillows and blankets","Ethernet connection",Microwave,"Coffee maker",Refrigerator,Dishwasher,"Dishes and silverware","Cooking basics",Oven,Stove,"Patio or balcony","Luggage dropoff allowed","Long term stays allowed","Wide hallways",Waterfront} | 2.0 | Real Bed | 2.0 | 3.0 | 2 | 2 | 0 | 0 | 100.0 | 83840 | none | 0.0 | 1 | 214559375 | 1.0 | 60.0 | 1.0 | 51.48173 | -0.17813 | Kensington and Chelsea | 0 | 0 | 400.0 | Apartment | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | 0.0 | SW10 |
| 82992 | 8 | {TV,Wifi,"Air conditioning",Kitchen,"Free parking on premises","Smoking allowed","Pets allowed",Elevator,Heating,"Suitable for events",Washer,Dryer,"Smoke detector","Carbon monoxide detector","First aid kit","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,"Hair dryer",Iron} | 3.0 | Real Bed | 4.0 | 4.0 | 1 | 1 | 0 | 0 | 0.0 | 83841 | none | 0.0 | 1 | 274979066 | 0.0 | NaN | 0.0 | 51.49769 | -0.17984 | Kensington and Chelsea | 0 | 0 | 500.0 | Condominium | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | 0.0 | SW7 5QQ |
| 82993 | 4 | {TV,Internet,Wifi,Kitchen,"Pets allowed",Gym,Elevator,"Free street parking",Heating,Washer,Dryer,"Smoke detector",Essentials,Shampoo,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Self check-in","Smart lock","Private entrance","Hot water","Luggage dropoff allowed","Long term stays allowed"} | 1.0 | Real Bed | 2.0 | 2.0 | 1 | 1 | 0 | 0 | 30.0 | 83842 | none | 20.0 | 2 | 98780515 | 3.0 | 100.0 | 3.0 | 51.48060 | -0.03378 | Lewisham | 0 | 0 | 100.0 | Apartment | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | 300.0 | SE14 6BY |
| 82994 | 4 | {Wifi,Kitchen,Heating,Washer,"Smoke detector",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace"} | 1.0 | Real Bed | 2.0 | 2.0 | 2 | 2 | 0 | 0 | 0.0 | 83843 | none | 0.0 | 1 | 9961640 | 2.0 | 100.0 | 2.0 | 51.53911 | -0.13478 | Camden | 0 | 0 | 160.0 | Townhouse | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | 0.0 | NW1 0BQ |
| 82995 | 1 | {Wifi,Kitchen,Heating,Washer,Dryer,"Smoke detector","Fire extinguisher",Essentials,Shampoo,"Lock on bedroom door",Hangers,Iron,"Hot water","Bed linens","Extra pillows and blankets","Garden or backyard"} | 1.5 | Real Bed | 1.0 | 1.0 | 6 | 0 | 6 | 0 | 20.0 | 83844 | none | 5.0 | 1 | 8484725 | 17.0 | 79.0 | 17.0 | 51.55124 | -0.04877 | Hackney | 0 | 0 | 20.0 | House | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Private room | 80.0 | E5 0LQ |
| 82996 | 4 | {Wifi,Kitchen,"Free parking on premises",Heating,"Smoke detector",Essentials,Hangers,"Hair dryer",Iron,"Laptop friendly workspace","Private entrance"} | 1.0 | Real Bed | 2.0 | 2.0 | 1 | 1 | 0 | 0 | 50.0 | 83845 | none | 40.0 | 1 | 90770681 | 1.0 | 67.0 | 1.0 | 51.53057 | -0.18423 | Westminster | 0 | 0 | 100.0 | Loft | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | 0.0 | NW8 9YB |
| 82997 | 1 | {TV,Wifi,Kitchen,Heating,"Smoke detector",Essentials,Iron,"Laptop friendly workspace"} | 1.0 | Real Bed | 1.0 | 1.0 | 18 | 18 | 0 | 0 | 0.0 | 83846 | none | 0.0 | 1 | 47609036 | 17.0 | 100.0 | 17.0 | 51.52301 | -0.08979 | Islington | 0 | 0 | 82.0 | Apartment | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | 0.0 | EC1Y 8TQ |
| 82998 | 1 | {TV,Wifi,Kitchen,Heating,"Smoke detector",Essentials,Iron,"Laptop friendly workspace"} | 1.0 | Real Bed | 1.0 | 1.0 | 18 | 18 | 0 | 0 | 0.0 | 83847 | none | 0.0 | 1 | 47609036 | 17.0 | 100.0 | 17.0 | 51.52301 | -0.08979 | Islington | 0 | 0 | 78.0 | Apartment | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | 0.0 | EC1Y 8TQ |
| 82999 | 2 | {TV,Wifi,Kitchen,Heating,"Smoke detector",Essentials,Iron,"Laptop friendly workspace"} | 1.0 | Real Bed | 1.0 | 1.0 | 18 | 18 | 0 | 0 | 0.0 | 83848 | none | 0.0 | 1 | 47609036 | 17.0 | 100.0 | 17.0 | 51.52301 | -0.08979 | Islington | 0 | 0 | 82.0 | Apartment | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | 0.0 | EC1Y 8TQ |
| 83000 | 2 | {Wifi,Kitchen,Essentials,"Hair dryer",Iron} | 1.0 | Real Bed | 1.0 | 1.0 | 18 | 18 | 0 | 0 | 0.0 | 83849 | none | 0.0 | 1 | 47609036 | 17.0 | 100.0 | 17.0 | 51.51050 | -0.01788 | Tower Hamlets | 0 | 0 | 72.0 | Apartment | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | Entire home/apt | 0.0 | E14 |